package com.pks.datacenter.dto;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;


/**
 * 数据库字段详情内容
 */
public class DbTableColumnInfo implements Serializable {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1389429541377682613L;
	
	public static List<String> MYSQL_NUMBER_FIELDS = new ArrayList<String>();
	public static List<String> MYSQL_STRING_FIELDS = new ArrayList<String>();
	public static List<String> MYSQL_DATE_FIELDS = new ArrayList<String>();
	static {
		MYSQL_NUMBER_FIELDS.addAll(Arrays.asList(new String[]{"int","bigint","tinyint","double","float","decimal"}));
		MYSQL_STRING_FIELDS.addAll(Arrays.asList(new String[]{"varchar","text","longtext","char"}));
		MYSQL_DATE_FIELDS.addAll(Arrays.asList(new String[]{"datetime","timestamp"}));
	}
	
	
	private String column_name;		//数据库字段名
	private String column_type;		//数据库字段类型 例：varchar(255)
	private String column_key;		//数据库字段是否为主键
	private String data_type;		//数据库字段数据类型  例 ： varchar
	private String column_comment;	//数据库字段注释文本
	
	public String getColumn_name() {
		return column_name;
	}
	public void setColumn_name(String column_name) {
		this.column_name = column_name;
	}
	public String getColumn_type() {
		return column_type;
	}
	public void setColumn_type(String column_type) {
		this.column_type = column_type;
	}
	public String getColumn_key() {
		return column_key;
	}
	public void setColumn_key(String column_key) {
		this.column_key = column_key;
	}
	public String getData_type() {
		return data_type;
	}
	public void setData_type(String data_type) {
		this.data_type = data_type;
	}
	public String getColumn_comment() {
		return column_comment;
	}
	public void setColumn_comment(String column_comment) {
		this.column_comment = column_comment;
	}
	
	
}
